Dataset statistics
| Number of variables | 28 |
|---|---|
| Number of observations | 91051 |
| Missing cells | 173710 |
| Missing cells (%) | 6.8% |
| Duplicate rows | 0 |
| Duplicate rows (%) | 0.0% |
| Total size in memory | 19.5 MiB |
| Average record size in memory | 224.0 B |
Variable types
| Numeric | 8 |
|---|---|
| Categorical | 16 |
| Unsupported | 4 |
tipo_persona has constant value "Natural" | Constant |
entidad has a high cardinality: 151 distinct values | High cardinality |
tipo_persona is highly correlated with genero and 13 other fields | High correlation |
genero is highly correlated with tipo_persona | High correlation |
tiene_casa_propia is highly correlated with tipo_persona | High correlation |
estado_civil is highly correlated with tipo_persona | High correlation |
codeudor is highly correlated with tipo_persona | High correlation |
municipio_expedicion is highly correlated with tipo_persona and 2 other fields | High correlation |
tipo_identificacion is highly correlated with tipo_persona | High correlation |
forma_pago is highly correlated with tipo_persona | High correlation |
municipio_nacimiento is highly correlated with tipo_persona and 2 other fields | High correlation |
estado_final is highly correlated with tipo_persona | High correlation |
tipo_venta is highly correlated with tipo_persona | High correlation |
periodo_credito is highly correlated with tipo_persona | High correlation |
sector is highly correlated with tipo_persona | High correlation |
municipio_residencia is highly correlated with tipo_persona and 2 other fields | High correlation |
municipio_credito is highly correlated with tipo_persona | High correlation |
empresa has 3993 (4.4%) missing values | Missing |
cargo has 6016 (6.6%) missing values | Missing |
tiempo_servicio has 17807 (19.6%) missing values | Missing |
otros_ingresos_mensual has 69003 (75.8%) missing values | Missing |
otros_ingresos_concepto has 76889 (84.4%) missing values | Missing |
sueldo is highly skewed (γ1 = 55.32638512) | Skewed |
otros_ingresos_mensual is highly skewed (γ1 = 55.03488623) | Skewed |
valor_credito is highly skewed (γ1 = 48.65011979) | Skewed |
Row is uniformly distributed | Uniform |
Row has unique values | Unique |
empresa is an unsupported type, check if it needs cleaning or further analysis | Unsupported |
cargo is an unsupported type, check if it needs cleaning or further analysis | Unsupported |
tiempo_servicio is an unsupported type, check if it needs cleaning or further analysis | Unsupported |
otros_ingresos_concepto is an unsupported type, check if it needs cleaning or further analysis | Unsupported |
otros_ingresos_mensual has 15962 (17.5%) zeros | Zeros |
Reproduction
| Analysis started | 2021-05-05 21:32:15.968012 |
|---|---|
| Analysis finished | 2021-05-05 21:32:57.509141 |
| Duration | 41.54 seconds |
| Software version | pandas-profiling v2.12.0 |
| Download configuration | config.yaml |
| Distinct | 91051 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 45526 |
| Minimum | 1 |
|---|---|
| Maximum | 91051 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 711.5 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 4553.5 |
| Q1 | 22763.5 |
| median | 45526 |
| Q3 | 68288.5 |
| 95-th percentile | 86498.5 |
| Maximum | 91051 |
| Range | 91050 |
| Interquartile range (IQR) | 45525 |
Descriptive statistics
| Standard deviation | 26284.30402 |
|---|---|
| Coefficient of variation (CV) | 0.5773470987 |
| Kurtosis | -1.2 |
| Mean | 45526 |
| Median Absolute Deviation (MAD) | 22763 |
| Skewness | 0 |
| Sum | 4145187826 |
| Variance | 690864637.7 |
| Monotonicity | Strictly increasing |
| Value | Count | Frequency (%) |
| 2047 | 1 | < 0.1% |
| 88702 | 1 | < 0.1% |
| 6806 | 1 | < 0.1% |
| 4759 | 1 | < 0.1% |
| 27288 | 1 | < 0.1% |
| 25241 | 1 | < 0.1% |
| 31386 | 1 | < 0.1% |
| 29339 | 1 | < 0.1% |
| 19100 | 1 | < 0.1% |
| 17053 | 1 | < 0.1% |
| Other values (91041) | 91041 |
| Value | Count | Frequency (%) |
| 1 | 1 | |
| 2 | 1 | |
| 3 | 1 | |
| 4 | 1 | |
| 5 | 1 |
| Value | Count | Frequency (%) |
| 91051 | 1 | |
| 91050 | 1 | |
| 91049 | 1 | |
| 91048 | 1 | |
| 91047 | 1 |
| Distinct | 6 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 711.5 KiB |
| Cedula de Ciudadania | |
|---|---|
| Cedula de Extranjeria | 262 |
| Tarjeta de Identidad | 23 |
| Registro Civil | 17 |
| NIT | 16 |
Length
| Max length | 21 |
|---|---|
| Median length | 20 |
| Mean length | 19.9985283 |
| Min length | 3 |
Characters and Unicode
| Total characters | 1820886 |
|---|---|
| Distinct characters | 24 |
| Distinct categories | 3 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Cedula de Ciudadania |
|---|---|
| 2nd row | Cedula de Ciudadania |
| 3rd row | Cedula de Ciudadania |
| 4th row | Cedula de Ciudadania |
| 5th row | Cedula de Ciudadania |
| Value | Count | Frequency (%) |
| Cedula de Ciudadania | 90731 | |
| Cedula de Extranjeria | 262 | 0.3% |
| Tarjeta de Identidad | 23 | < 0.1% |
| Registro Civil | 17 | < 0.1% |
| NIT | 16 | < 0.1% |
| Pasaporte | 2 | < 0.1% |
| Value | Count | Frequency (%) |
| de | 91016 | |
| cedula | 90993 | |
| ciudadania | 90731 | |
| extranjeria | 262 | 0.1% |
| tarjeta | 23 | < 0.1% |
| identidad | 23 | < 0.1% |
| registro | 17 | < 0.1% |
| civil | 17 | < 0.1% |
| nit | 16 | < 0.1% |
| pasaporte | 2 | < 0.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| a | 363783 | |
| d | 363540 | |
| e | 182336 | |
| 182049 | ||
| i | 181798 | |
| C | 181741 | |
| u | 181724 | |
| n | 91016 | 5.0% |
| l | 91010 | 5.0% |
| r | 566 | < 0.1% |
| Other values (14) | 1323 | 0.1% |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 1456721 | |
| Uppercase Letter | 182116 | 10.0% |
| Space Separator | 182049 | 10.0% |
Most frequent character per category
| Value | Count | Frequency (%) |
| a | 363783 | |
| d | 363540 | |
| e | 182336 | |
| i | 181798 | |
| u | 181724 | |
| n | 91016 | 6.2% |
| l | 91010 | 6.2% |
| r | 566 | < 0.1% |
| t | 327 | < 0.1% |
| j | 285 | < 0.1% |
| Other values (6) | 336 | < 0.1% |
| Value | Count | Frequency (%) |
| C | 181741 | |
| E | 262 | 0.1% |
| I | 39 | < 0.1% |
| T | 39 | < 0.1% |
| R | 17 | < 0.1% |
| N | 16 | < 0.1% |
| P | 2 | < 0.1% |
| Value | Count | Frequency (%) |
| 182049 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 1638837 | |
| Common | 182049 | 10.0% |
Most frequent character per script
| Value | Count | Frequency (%) |
| a | 363783 | |
| d | 363540 | |
| e | 182336 | |
| i | 181798 | |
| C | 181741 | |
| u | 181724 | |
| n | 91016 | 5.6% |
| l | 91010 | 5.6% |
| r | 566 | < 0.1% |
| t | 327 | < 0.1% |
| Other values (13) | 996 | 0.1% |
| Value | Count | Frequency (%) |
| 182049 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 1820886 |
Most frequent character per block
| Value | Count | Frequency (%) |
| a | 363783 | |
| d | 363540 | |
| e | 182336 | |
| 182049 | ||
| i | 181798 | |
| C | 181741 | |
| u | 181724 | |
| n | 91016 | 5.0% |
| l | 91010 | 5.0% |
| r | 566 | < 0.1% |
| Other values (14) | 1323 | 0.1% |
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 711.5 KiB |
| Femenino | |
|---|---|
| Masculino |
Length
| Max length | 9 |
|---|---|
| Median length | 8 |
| Mean length | 8.458644057 |
| Min length | 8 |
Characters and Unicode
| Total characters | 770168 |
|---|---|
| Distinct characters | 12 |
| Distinct categories | 2 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Femenino |
|---|---|
| 2nd row | Femenino |
| 3rd row | Femenino |
| 4th row | Femenino |
| 5th row | Femenino |
| Value | Count | Frequency (%) |
| Femenino | 49291 | |
| Masculino | 41760 |
| Value | Count | Frequency (%) |
| femenino | 49291 | |
| masculino | 41760 |
Most occurring characters
| Value | Count | Frequency (%) |
| n | 140342 | |
| e | 98582 | |
| i | 91051 | |
| o | 91051 | |
| F | 49291 | 6.4% |
| m | 49291 | 6.4% |
| M | 41760 | 5.4% |
| a | 41760 | 5.4% |
| s | 41760 | 5.4% |
| c | 41760 | 5.4% |
| Other values (2) | 83520 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 679117 | |
| Uppercase Letter | 91051 | 11.8% |
Most frequent character per category
| Value | Count | Frequency (%) |
| n | 140342 | |
| e | 98582 | |
| i | 91051 | |
| o | 91051 | |
| m | 49291 | 7.3% |
| a | 41760 | 6.1% |
| s | 41760 | 6.1% |
| c | 41760 | 6.1% |
| u | 41760 | 6.1% |
| l | 41760 | 6.1% |
| Value | Count | Frequency (%) |
| F | 49291 | |
| M | 41760 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 770168 |
Most frequent character per script
| Value | Count | Frequency (%) |
| n | 140342 | |
| e | 98582 | |
| i | 91051 | |
| o | 91051 | |
| F | 49291 | 6.4% |
| m | 49291 | 6.4% |
| M | 41760 | 5.4% |
| a | 41760 | 5.4% |
| s | 41760 | 5.4% |
| c | 41760 | 5.4% |
| Other values (2) | 83520 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 770168 |
Most frequent character per block
| Value | Count | Frequency (%) |
| n | 140342 | |
| e | 98582 | |
| i | 91051 | |
| o | 91051 | |
| F | 49291 | 6.4% |
| m | 49291 | 6.4% |
| M | 41760 | 5.4% |
| a | 41760 | 5.4% |
| s | 41760 | 5.4% |
| c | 41760 | 5.4% |
| Other values (2) | 83520 |
| Distinct | 5 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 711.5 KiB |
| Union Libre | |
|---|---|
| Casado | |
| Soltero | |
| Viudo | 862 |
| Divorciado | 560 |
Length
| Max length | 11 |
|---|---|
| Median length | 7 |
| Mean length | 8.223413252 |
| Min length | 5 |
Characters and Unicode
| Total characters | 748750 |
|---|---|
| Distinct characters | 21 |
| Distinct categories | 3 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Soltero |
|---|---|
| 2nd row | Union Libre |
| 3rd row | Union Libre |
| 4th row | Casado |
| 5th row | Soltero |
| Value | Count | Frequency (%) |
| Union Libre | 34793 | |
| Casado | 27735 | |
| Soltero | 27101 | |
| Viudo | 862 | 0.9% |
| Divorciado | 560 | 0.6% |
| Value | Count | Frequency (%) |
| libre | 34793 | |
| union | 34793 | |
| casado | 27735 | |
| soltero | 27101 | |
| viudo | 862 | 0.7% |
| divorciado | 560 | 0.4% |
Most occurring characters
| Value | Count | Frequency (%) |
| o | 118712 | |
| i | 71568 | |
| n | 69586 | |
| r | 62454 | 8.3% |
| e | 61894 | 8.3% |
| a | 56030 | 7.5% |
| U | 34793 | 4.6% |
| 34793 | 4.6% | |
| L | 34793 | 4.6% |
| b | 34793 | 4.6% |
| Other values (11) | 169334 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 588113 | |
| Uppercase Letter | 125844 | 16.8% |
| Space Separator | 34793 | 4.6% |
Most frequent character per category
| Value | Count | Frequency (%) |
| o | 118712 | |
| i | 71568 | |
| n | 69586 | |
| r | 62454 | |
| e | 61894 | |
| a | 56030 | |
| b | 34793 | 5.9% |
| d | 29157 | 5.0% |
| s | 27735 | 4.7% |
| l | 27101 | 4.6% |
| Other values (4) | 29083 | 4.9% |
| Value | Count | Frequency (%) |
| U | 34793 | |
| L | 34793 | |
| C | 27735 | |
| S | 27101 | |
| V | 862 | 0.7% |
| D | 560 | 0.4% |
| Value | Count | Frequency (%) |
| 34793 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 713957 | |
| Common | 34793 | 4.6% |
Most frequent character per script
| Value | Count | Frequency (%) |
| o | 118712 | |
| i | 71568 | |
| n | 69586 | |
| r | 62454 | |
| e | 61894 | |
| a | 56030 | 7.8% |
| U | 34793 | 4.9% |
| L | 34793 | 4.9% |
| b | 34793 | 4.9% |
| d | 29157 | 4.1% |
| Other values (10) | 140177 |
| Value | Count | Frequency (%) |
| 34793 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 748750 |
Most frequent character per block
| Value | Count | Frequency (%) |
| o | 118712 | |
| i | 71568 | |
| n | 69586 | |
| r | 62454 | 8.3% |
| e | 61894 | 8.3% |
| a | 56030 | 7.5% |
| U | 34793 | 4.6% |
| 34793 | 4.6% | |
| L | 34793 | 4.6% |
| b | 34793 | 4.6% |
| Other values (11) | 169334 |
edad
Real number (ℝ≥0)
| Distinct | 73 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 44.11897728 |
| Minimum | 18 |
|---|---|
| Maximum | 98 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 711.5 KiB |
Quantile statistics
| Minimum | 18 |
|---|---|
| 5-th percentile | 26 |
| Q1 | 35 |
| median | 43 |
| Q3 | 52 |
| 95-th percentile | 64 |
| Maximum | 98 |
| Range | 80 |
| Interquartile range (IQR) | 17 |
Descriptive statistics
| Standard deviation | 11.92193633 |
|---|---|
| Coefficient of variation (CV) | 0.2702224092 |
| Kurtosis | -0.3788885876 |
| Mean | 44.11897728 |
| Median Absolute Deviation (MAD) | 9 |
| Skewness | 0.3402068718 |
| Sum | 4017077 |
| Variance | 142.1325658 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 44 | 3404 | 3.7% |
| 40 | 3167 | 3.5% |
| 41 | 2933 | 3.2% |
| 45 | 2857 | 3.1% |
| 35 | 2814 | 3.1% |
| 49 | 2752 | 3.0% |
| 46 | 2687 | 3.0% |
| 36 | 2646 | 2.9% |
| 31 | 2597 | 2.9% |
| 39 | 2567 | 2.8% |
| Other values (63) | 62627 |
| Value | Count | Frequency (%) |
| 18 | 12 | < 0.1% |
| 19 | 66 | 0.1% |
| 20 | 214 | |
| 21 | 292 | |
| 22 | 459 |
| Value | Count | Frequency (%) |
| 98 | 2 | |
| 90 | 3 | |
| 89 | 1 | < 0.1% |
| 88 | 2 | |
| 87 | 1 | < 0.1% |
| Distinct | 27 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 711.5 KiB |
| ARAUCA | |
|---|---|
| TAME | |
| ARAUQUITA | |
| PUERTO RONDON | |
| SARAVENA | |
| Other values (22) |
Length
| Max length | 14 |
|---|---|
| Median length | 6 |
| Mean length | 6.560235472 |
| Min length | 4 |
Characters and Unicode
| Total characters | 597316 |
|---|---|
| Distinct characters | 26 |
| Distinct categories | 3 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 2 ? |
Unique
| Unique | 4 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | ARAUCA |
|---|---|
| 2nd row | ARAUCA |
| 3rd row | ARAUCA |
| 4th row | ARAUCA |
| 5th row | ARAUCA |
| Value | Count | Frequency (%) |
| ARAUCA | 39509 | |
| TAME | 24617 | |
| ARAUQUITA | 9258 | 10.2% |
| PUERTO RONDON | 4662 | 5.1% |
| SARAVENA | 4288 | 4.7% |
| PUERTO JORDAN | 4161 | 4.6% |
| FORTUL | 3653 | 4.0% |
| PANAMA | 335 | 0.4% |
| HATO COROZAL | 213 | 0.2% |
| CRAVO NORTE | 148 | 0.2% |
| Other values (17) | 207 | 0.2% |
| Value | Count | Frequency (%) |
| arauca | 39509 | |
| tame | 24617 | |
| arauquita | 9258 | 9.2% |
| puerto | 8823 | 8.8% |
| rondon | 4662 | 4.7% |
| saravena | 4288 | 4.3% |
| jordan | 4161 | 4.2% |
| fortul | 3653 | 3.6% |
| panama | 335 | 0.3% |
| hato | 213 | 0.2% |
| Other values (24) | 726 | 0.7% |
Most occurring characters
| Value | Count | Frequency (%) |
| A | 189904 | |
| R | 74983 | 12.6% |
| U | 70629 | 11.8% |
| T | 46750 | 7.8% |
| C | 40043 | 6.7% |
| E | 37930 | 6.4% |
| O | 26928 | 4.5% |
| M | 24997 | 4.2% |
| N | 18280 | 3.1% |
| I | 9312 | 1.6% |
| Other values (16) | 57560 | 9.6% |
Most occurring categories
| Value | Count | Frequency (%) |
| Uppercase Letter | 588121 | |
| Space Separator | 9194 | 1.5% |
| Other Punctuation | 1 | < 0.1% |
Most frequent character per category
| Value | Count | Frequency (%) |
| A | 189904 | |
| R | 74983 | 12.7% |
| U | 70629 | 12.0% |
| T | 46750 | 7.9% |
| C | 40043 | 6.8% |
| E | 37930 | 6.4% |
| O | 26928 | 4.6% |
| M | 24997 | 4.3% |
| N | 18280 | 3.1% |
| I | 9312 | 1.6% |
| Other values (14) | 48365 | 8.2% |
| Value | Count | Frequency (%) |
| 9194 |
| Value | Count | Frequency (%) |
| . | 1 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 588121 | |
| Common | 9195 | 1.5% |
Most frequent character per script
| Value | Count | Frequency (%) |
| A | 189904 | |
| R | 74983 | 12.7% |
| U | 70629 | 12.0% |
| T | 46750 | 7.9% |
| C | 40043 | 6.8% |
| E | 37930 | 6.4% |
| O | 26928 | 4.6% |
| M | 24997 | 4.3% |
| N | 18280 | 3.1% |
| I | 9312 | 1.6% |
| Other values (14) | 48365 | 8.2% |
| Value | Count | Frequency (%) |
| 9194 | ||
| . | 1 | < 0.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 597315 | |
| None | 1 | < 0.1% |
Most frequent character per block
| Value | Count | Frequency (%) |
| A | 189904 | |
| R | 74983 | 12.6% |
| U | 70629 | 11.8% |
| T | 46750 | 7.8% |
| C | 40043 | 6.7% |
| E | 37930 | 6.4% |
| O | 26928 | 4.5% |
| M | 24997 | 4.2% |
| N | 18280 | 3.1% |
| I | 9312 | 1.6% |
| Other values (15) | 57559 | 9.6% |
| Value | Count | Frequency (%) |
| Á | 1 |
| Distinct | 1 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 711.5 KiB |
| Natural |
|---|
Length
| Max length | 7 |
|---|---|
| Median length | 7 |
| Mean length | 7 |
| Min length | 7 |
Characters and Unicode
| Total characters | 637357 |
|---|---|
| Distinct characters | 6 |
| Distinct categories | 2 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Natural |
|---|---|
| 2nd row | Natural |
| 3rd row | Natural |
| 4th row | Natural |
| 5th row | Natural |
| Value | Count | Frequency (%) |
| Natural | 91051 |
| Value | Count | Frequency (%) |
| natural | 91051 |
Most occurring characters
| Value | Count | Frequency (%) |
| a | 182102 | |
| N | 91051 | |
| t | 91051 | |
| u | 91051 | |
| r | 91051 | |
| l | 91051 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 546306 | |
| Uppercase Letter | 91051 | 14.3% |
Most frequent character per category
| Value | Count | Frequency (%) |
| a | 182102 | |
| t | 91051 | |
| u | 91051 | |
| r | 91051 | |
| l | 91051 |
| Value | Count | Frequency (%) |
| N | 91051 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 637357 |
Most frequent character per script
| Value | Count | Frequency (%) |
| a | 182102 | |
| N | 91051 | |
| t | 91051 | |
| u | 91051 | |
| r | 91051 | |
| l | 91051 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 637357 |
Most frequent character per block
| Value | Count | Frequency (%) |
| a | 182102 | |
| N | 91051 | |
| t | 91051 | |
| u | 91051 | |
| r | 91051 | |
| l | 91051 |
| Distinct | 27 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 711.5 KiB |
| ARAUCA | |
|---|---|
| TAME | |
| ARAUQUITA | |
| PUERTO RONDON | |
| SARAVENA | |
| Other values (22) |
Length
| Max length | 14 |
|---|---|
| Median length | 6 |
| Mean length | 6.560235472 |
| Min length | 4 |
Characters and Unicode
| Total characters | 597316 |
|---|---|
| Distinct characters | 26 |
| Distinct categories | 3 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 2 ? |
Unique
| Unique | 4 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | ARAUCA |
|---|---|
| 2nd row | ARAUCA |
| 3rd row | ARAUCA |
| 4th row | ARAUCA |
| 5th row | ARAUCA |
| Value | Count | Frequency (%) |
| ARAUCA | 39509 | |
| TAME | 24617 | |
| ARAUQUITA | 9258 | 10.2% |
| PUERTO RONDON | 4662 | 5.1% |
| SARAVENA | 4288 | 4.7% |
| PUERTO JORDAN | 4161 | 4.6% |
| FORTUL | 3653 | 4.0% |
| PANAMA | 335 | 0.4% |
| HATO COROZAL | 213 | 0.2% |
| CRAVO NORTE | 148 | 0.2% |
| Other values (17) | 207 | 0.2% |
| Value | Count | Frequency (%) |
| arauca | 39509 | |
| tame | 24617 | |
| arauquita | 9258 | 9.2% |
| puerto | 8823 | 8.8% |
| rondon | 4662 | 4.7% |
| saravena | 4288 | 4.3% |
| jordan | 4161 | 4.2% |
| fortul | 3653 | 3.6% |
| panama | 335 | 0.3% |
| hato | 213 | 0.2% |
| Other values (24) | 726 | 0.7% |
Most occurring characters
| Value | Count | Frequency (%) |
| A | 189904 | |
| R | 74983 | 12.6% |
| U | 70629 | 11.8% |
| T | 46750 | 7.8% |
| C | 40043 | 6.7% |
| E | 37930 | 6.4% |
| O | 26928 | 4.5% |
| M | 24997 | 4.2% |
| N | 18280 | 3.1% |
| I | 9312 | 1.6% |
| Other values (16) | 57560 | 9.6% |
Most occurring categories
| Value | Count | Frequency (%) |
| Uppercase Letter | 588121 | |
| Space Separator | 9194 | 1.5% |
| Other Punctuation | 1 | < 0.1% |
Most frequent character per category
| Value | Count | Frequency (%) |
| A | 189904 | |
| R | 74983 | 12.7% |
| U | 70629 | 12.0% |
| T | 46750 | 7.9% |
| C | 40043 | 6.8% |
| E | 37930 | 6.4% |
| O | 26928 | 4.6% |
| M | 24997 | 4.3% |
| N | 18280 | 3.1% |
| I | 9312 | 1.6% |
| Other values (14) | 48365 | 8.2% |
| Value | Count | Frequency (%) |
| 9194 |
| Value | Count | Frequency (%) |
| . | 1 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 588121 | |
| Common | 9195 | 1.5% |
Most frequent character per script
| Value | Count | Frequency (%) |
| A | 189904 | |
| R | 74983 | 12.7% |
| U | 70629 | 12.0% |
| T | 46750 | 7.9% |
| C | 40043 | 6.8% |
| E | 37930 | 6.4% |
| O | 26928 | 4.6% |
| M | 24997 | 4.3% |
| N | 18280 | 3.1% |
| I | 9312 | 1.6% |
| Other values (14) | 48365 | 8.2% |
| Value | Count | Frequency (%) |
| 9194 | ||
| . | 1 | < 0.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 597315 | |
| None | 1 | < 0.1% |
Most frequent character per block
| Value | Count | Frequency (%) |
| A | 189904 | |
| R | 74983 | 12.6% |
| U | 70629 | 11.8% |
| T | 46750 | 7.8% |
| C | 40043 | 6.7% |
| E | 37930 | 6.4% |
| O | 26928 | 4.5% |
| M | 24997 | 4.2% |
| N | 18280 | 3.1% |
| I | 9312 | 1.6% |
| Other values (15) | 57559 | 9.6% |
| Value | Count | Frequency (%) |
| Á | 1 |
| Distinct | 27 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 711.5 KiB |
| ARAUCA | |
|---|---|
| TAME | |
| ARAUQUITA | |
| PUERTO RONDON | |
| SARAVENA | |
| Other values (22) |
Length
| Max length | 14 |
|---|---|
| Median length | 6 |
| Mean length | 6.560235472 |
| Min length | 4 |
Characters and Unicode
| Total characters | 597316 |
|---|---|
| Distinct characters | 26 |
| Distinct categories | 3 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 2 ? |
Unique
| Unique | 4 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | ARAUCA |
|---|---|
| 2nd row | ARAUCA |
| 3rd row | ARAUCA |
| 4th row | ARAUCA |
| 5th row | ARAUCA |
| Value | Count | Frequency (%) |
| ARAUCA | 39509 | |
| TAME | 24617 | |
| ARAUQUITA | 9258 | 10.2% |
| PUERTO RONDON | 4662 | 5.1% |
| SARAVENA | 4288 | 4.7% |
| PUERTO JORDAN | 4161 | 4.6% |
| FORTUL | 3653 | 4.0% |
| PANAMA | 335 | 0.4% |
| HATO COROZAL | 213 | 0.2% |
| CRAVO NORTE | 148 | 0.2% |
| Other values (17) | 207 | 0.2% |
| Value | Count | Frequency (%) |
| arauca | 39509 | |
| tame | 24617 | |
| arauquita | 9258 | 9.2% |
| puerto | 8823 | 8.8% |
| rondon | 4662 | 4.7% |
| saravena | 4288 | 4.3% |
| jordan | 4161 | 4.2% |
| fortul | 3653 | 3.6% |
| panama | 335 | 0.3% |
| hato | 213 | 0.2% |
| Other values (24) | 726 | 0.7% |
Most occurring characters
| Value | Count | Frequency (%) |
| A | 189904 | |
| R | 74983 | 12.6% |
| U | 70629 | 11.8% |
| T | 46750 | 7.8% |
| C | 40043 | 6.7% |
| E | 37930 | 6.4% |
| O | 26928 | 4.5% |
| M | 24997 | 4.2% |
| N | 18280 | 3.1% |
| I | 9312 | 1.6% |
| Other values (16) | 57560 | 9.6% |
Most occurring categories
| Value | Count | Frequency (%) |
| Uppercase Letter | 588121 | |
| Space Separator | 9194 | 1.5% |
| Other Punctuation | 1 | < 0.1% |
Most frequent character per category
| Value | Count | Frequency (%) |
| A | 189904 | |
| R | 74983 | 12.7% |
| U | 70629 | 12.0% |
| T | 46750 | 7.9% |
| C | 40043 | 6.8% |
| E | 37930 | 6.4% |
| O | 26928 | 4.6% |
| M | 24997 | 4.3% |
| N | 18280 | 3.1% |
| I | 9312 | 1.6% |
| Other values (14) | 48365 | 8.2% |
| Value | Count | Frequency (%) |
| 9194 |
| Value | Count | Frequency (%) |
| . | 1 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 588121 | |
| Common | 9195 | 1.5% |
Most frequent character per script
| Value | Count | Frequency (%) |
| A | 189904 | |
| R | 74983 | 12.7% |
| U | 70629 | 12.0% |
| T | 46750 | 7.9% |
| C | 40043 | 6.8% |
| E | 37930 | 6.4% |
| O | 26928 | 4.6% |
| M | 24997 | 4.3% |
| N | 18280 | 3.1% |
| I | 9312 | 1.6% |
| Other values (14) | 48365 | 8.2% |
| Value | Count | Frequency (%) |
| 9194 | ||
| . | 1 | < 0.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 597315 | |
| None | 1 | < 0.1% |
Most frequent character per block
| Value | Count | Frequency (%) |
| A | 189904 | |
| R | 74983 | 12.6% |
| U | 70629 | 11.8% |
| T | 46750 | 7.8% |
| C | 40043 | 6.7% |
| E | 37930 | 6.4% |
| O | 26928 | 4.5% |
| M | 24997 | 4.2% |
| N | 18280 | 3.1% |
| I | 9312 | 1.6% |
| Other values (15) | 57559 | 9.6% |
| Value | Count | Frequency (%) |
| Á | 1 |
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 711.5 KiB |
| Si | |
|---|---|
| No |
Length
| Max length | 2 |
|---|---|
| Median length | 2 |
| Mean length | 2 |
| Min length | 2 |
Characters and Unicode
| Total characters | 182102 |
|---|---|
| Distinct characters | 4 |
| Distinct categories | 2 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Si |
|---|---|
| 2nd row | No |
| 3rd row | No |
| 4th row | Si |
| 5th row | Si |
| Value | Count | Frequency (%) |
| Si | 64707 | |
| No | 26344 |
| Value | Count | Frequency (%) |
| si | 64707 | |
| no | 26344 |
Most occurring characters
| Value | Count | Frequency (%) |
| S | 64707 | |
| i | 64707 | |
| N | 26344 | |
| o | 26344 |
Most occurring categories
| Value | Count | Frequency (%) |
| Uppercase Letter | 91051 | |
| Lowercase Letter | 91051 |
Most frequent character per category
| Value | Count | Frequency (%) |
| S | 64707 | |
| N | 26344 |
| Value | Count | Frequency (%) |
| i | 64707 | |
| o | 26344 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 182102 |
Most frequent character per script
| Value | Count | Frequency (%) |
| S | 64707 | |
| i | 64707 | |
| N | 26344 | |
| o | 26344 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 182102 |
Most frequent character per block
| Value | Count | Frequency (%) |
| S | 64707 | |
| i | 64707 | |
| N | 26344 | |
| o | 26344 |
| Distinct | 683 |
|---|---|
| Distinct (%) | 0.8% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2859056.528 |
| Minimum | 0 |
|---|---|
| Maximum | 3204740882 |
| Zeros | 356 |
| Zeros (%) | 0.4% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 711.5 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 700000 |
| Q1 | 908526 |
| median | 1500000 |
| Q3 | 2500000 |
| 95-th percentile | 4500000 |
| Maximum | 3204740882 |
| Range | 3204740882 |
| Interquartile range (IQR) | 1591474 |
Descriptive statistics
| Standard deviation | 46992377.74 |
|---|---|
| Coefficient of variation (CV) | 16.43632341 |
| Kurtosis | 3260.557737 |
| Mean | 2859056.528 |
| Median Absolute Deviation (MAD) | 591474 |
| Skewness | 55.32638512 |
| Sum | 2.603199559 × 1011 |
| Variance | 2.208283565 × 1015 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 908526 | 11022 | 12.1% |
| 2000000 | 9250 | 10.2% |
| 1000000 | 7714 | 8.5% |
| 1500000 | 6764 | 7.4% |
| 1200000 | 5502 | 6.0% |
| 3000000 | 4903 | 5.4% |
| 800000 | 3043 | 3.3% |
| 4000000 | 2992 | 3.3% |
| 1800000 | 2854 | 3.1% |
| 2500000 | 2744 | 3.0% |
| Other values (673) | 34263 |
| Value | Count | Frequency (%) |
| 0 | 356 | |
| 152 | 131 | 0.1% |
| 800 | 2 | < 0.1% |
| 30000 | 1 | < 0.1% |
| 93000 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 3204740882 | 3 | < 0.1% |
| 3203428840 | 2 | < 0.1% |
| 3174339461 | 3 | < 0.1% |
| 3016878081 | 4 | < 0.1% |
| 2000000000 | 16 |
| Distinct | 96 |
|---|---|
| Distinct (%) | 0.4% |
| Missing | 69003 |
| Missing (%) | 75.8% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1421263.051 |
| Minimum | 0 |
|---|---|
| Maximum | 3143089323 |
| Zeros | 15962 |
| Zeros (%) | 17.5% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 711.5 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 300000 |
| 95-th percentile | 2000000 |
| Maximum | 3143089323 |
| Range | 3143089323 |
| Interquartile range (IQR) | 300000 |
Descriptive statistics
| Standard deviation | 56019916.75 |
|---|---|
| Coefficient of variation (CV) | 39.41558652 |
| Kurtosis | 3051.499426 |
| Mean | 1421263.051 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 55.03488623 |
| Sum | 3.133600775 × 1010 |
| Variance | 3.138231073 × 1015 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 15962 | 17.5% |
| 1000000 | 894 | 1.0% |
| 500000 | 706 | 0.8% |
| 400000 | 506 | 0.6% |
| 600000 | 423 | 0.5% |
| 2000000 | 388 | 0.4% |
| 800000 | 337 | 0.4% |
| 200000 | 319 | 0.4% |
| 300000 | 279 | 0.3% |
| 1500000 | 234 | 0.3% |
| Other values (86) | 2000 | 2.2% |
| (Missing) | 69003 |
| Value | Count | Frequency (%) |
| 0 | 15962 | |
| 50000 | 3 | < 0.1% |
| 80000 | 2 | < 0.1% |
| 100000 | 79 | 0.1% |
| 120000 | 7 | < 0.1% |
| Value | Count | Frequency (%) |
| 3143089323 | 1 | < 0.1% |
| 3118534287 | 2 | < 0.1% |
| 3114770734 | 4 | < 0.1% |
| 1000000000 | 1 | < 0.1% |
| 60000000 | 18 |
| Distinct | 9 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 711.5 KiB |
| ARAUCA | |
|---|---|
| TAME | |
| ARAUQUITA | |
| SARAVENA | |
| PUERTO RONDON | 3691 |
| Other values (4) |
Length
| Max length | 13 |
|---|---|
| Median length | 6 |
| Mean length | 6.43173606 |
| Min length | 4 |
Characters and Unicode
| Total characters | 585616 |
|---|---|
| Distinct characters | 19 |
| Distinct categories | 2 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | ARAUCA |
|---|---|
| 2nd row | ARAUCA |
| 3rd row | ARAUCA |
| 4th row | ARAUCA |
| 5th row | ARAUCA |
| Value | Count | Frequency (%) |
| ARAUCA | 40815 | |
| TAME | 25122 | |
| ARAUQUITA | 8799 | 9.7% |
| SARAVENA | 5845 | 6.4% |
| PUERTO RONDON | 3691 | 4.1% |
| PUERTO JORDAN | 3660 | 4.0% |
| FORTUL | 3066 | 3.4% |
| PANAMA | 51 | 0.1% |
| CRAVO NORTE | 2 | < 0.1% |
| Value | Count | Frequency (%) |
| arauca | 40815 | |
| tame | 25122 | |
| arauquita | 8799 | 8.9% |
| puerto | 7351 | 7.5% |
| saravena | 5845 | 5.9% |
| rondon | 3691 | 3.8% |
| jordan | 3660 | 3.7% |
| fortul | 3066 | 3.1% |
| panama | 51 | 0.1% |
| norte | 2 | < 0.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| A | 195314 | |
| R | 73231 | 12.5% |
| U | 68830 | 11.8% |
| T | 44340 | 7.6% |
| C | 40817 | 7.0% |
| E | 38320 | 6.5% |
| M | 25173 | 4.3% |
| O | 21463 | 3.7% |
| N | 16940 | 2.9% |
| Q | 8799 | 1.5% |
| Other values (9) | 52389 | 8.9% |
Most occurring categories
| Value | Count | Frequency (%) |
| Uppercase Letter | 578263 | |
| Space Separator | 7353 | 1.3% |
Most frequent character per category
| Value | Count | Frequency (%) |
| A | 195314 | |
| R | 73231 | 12.7% |
| U | 68830 | 11.9% |
| T | 44340 | 7.7% |
| C | 40817 | 7.1% |
| E | 38320 | 6.6% |
| M | 25173 | 4.4% |
| O | 21463 | 3.7% |
| N | 16940 | 2.9% |
| Q | 8799 | 1.5% |
| Other values (8) | 45036 | 7.8% |
| Value | Count | Frequency (%) |
| 7353 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 578263 | |
| Common | 7353 | 1.3% |
Most frequent character per script
| Value | Count | Frequency (%) |
| A | 195314 | |
| R | 73231 | 12.7% |
| U | 68830 | 11.9% |
| T | 44340 | 7.7% |
| C | 40817 | 7.1% |
| E | 38320 | 6.6% |
| M | 25173 | 4.4% |
| O | 21463 | 3.7% |
| N | 16940 | 2.9% |
| Q | 8799 | 1.5% |
| Other values (8) | 45036 | 7.8% |
| Value | Count | Frequency (%) |
| 7353 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 585616 |
Most frequent character per block
| Value | Count | Frequency (%) |
| A | 195314 | |
| R | 73231 | 12.5% |
| U | 68830 | 11.8% |
| T | 44340 | 7.6% |
| C | 40817 | 7.0% |
| E | 38320 | 6.5% |
| M | 25173 | 4.3% |
| O | 21463 | 3.7% |
| N | 16940 | 2.9% |
| Q | 8799 | 1.5% |
| Other values (9) | 52389 | 8.9% |
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 711.5 KiB |
| SIN CODEUDOR | |
|---|---|
| CON CODEUDOR |
Length
| Max length | 12 |
|---|---|
| Median length | 12 |
| Mean length | 12 |
| Min length | 12 |
Characters and Unicode
| Total characters | 1092612 |
|---|---|
| Distinct characters | 10 |
| Distinct categories | 2 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | SIN CODEUDOR |
|---|---|
| 2nd row | SIN CODEUDOR |
| 3rd row | SIN CODEUDOR |
| 4th row | SIN CODEUDOR |
| 5th row | SIN CODEUDOR |
| Value | Count | Frequency (%) |
| SIN CODEUDOR | 80127 | |
| CON CODEUDOR | 10924 | 12.0% |
| Value | Count | Frequency (%) |
| codeudor | 91051 | |
| sin | 80127 | |
| con | 10924 | 6.0% |
Most occurring characters
| Value | Count | Frequency (%) |
| O | 193026 | |
| D | 182102 | |
| C | 101975 | |
| N | 91051 | |
| 91051 | ||
| E | 91051 | |
| U | 91051 | |
| R | 91051 | |
| S | 80127 | |
| I | 80127 |
Most occurring categories
| Value | Count | Frequency (%) |
| Uppercase Letter | 1001561 | |
| Space Separator | 91051 | 8.3% |
Most frequent character per category
| Value | Count | Frequency (%) |
| O | 193026 | |
| D | 182102 | |
| C | 101975 | |
| N | 91051 | |
| E | 91051 | |
| U | 91051 | |
| R | 91051 | |
| S | 80127 | |
| I | 80127 |
| Value | Count | Frequency (%) |
| 91051 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 1001561 | |
| Common | 91051 | 8.3% |
Most frequent character per script
| Value | Count | Frequency (%) |
| O | 193026 | |
| D | 182102 | |
| C | 101975 | |
| N | 91051 | |
| E | 91051 | |
| U | 91051 | |
| R | 91051 | |
| S | 80127 | |
| I | 80127 |
| Value | Count | Frequency (%) |
| 91051 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 1092612 |
Most frequent character per block
| Value | Count | Frequency (%) |
| O | 193026 | |
| D | 182102 | |
| C | 101975 | |
| N | 91051 | |
| 91051 | ||
| E | 91051 | |
| U | 91051 | |
| R | 91051 | |
| S | 80127 | |
| I | 80127 |
| Distinct | 151 |
|---|---|
| Distinct (%) | 0.2% |
| Missing | 1 |
| Missing (%) | < 0.1% |
| Memory size | 711.5 KiB |
| INDEPENDIENTES ARAUCA | |
|---|---|
| CONTADO | |
| CREDITOS TAME | |
| CONTADOS DE TAME | |
| INDEP. ARAUQUITA | |
| Other values (146) |
Length
| Max length | 35 |
|---|---|
| Median length | 16 |
| Mean length | 15.8190335 |
| Min length | 6 |
Characters and Unicode
| Total characters | 1440323 |
|---|---|
| Distinct characters | 44 |
| Distinct categories | 8 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 2 ? |
Unique
| Unique | 15 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | ALCALDIA DE ARAUCA |
|---|---|
| 2nd row | ALCALDIA DE ARAUCA |
| 3rd row | ALCALDIA DE ARAUCA |
| 4th row | ALCALDIA DE ARAUCA |
| 5th row | ALCALDIA DE ARAUCA |
| Value | Count | Frequency (%) |
| INDEPENDIENTES ARAUCA | 20352 | |
| CONTADO | 11306 | |
| CREDITOS TAME | 11002 | |
| CONTADOS DE TAME | 8120 | 8.9% |
| INDEP. ARAUQUITA | 5015 | 5.5% |
| PUEBLO NUEVO | 3068 | 3.4% |
| FORTUL | 2950 | 3.2% |
| CONTADOS ARAUQUITA | 2919 | 3.2% |
| PUERTO RONDON | 2896 | 3.2% |
| FONDO EDUCATIVO REGIONAL | 2584 | 2.8% |
| Other values (141) | 20838 |
| Value | Count | Frequency (%) |
| arauca | 24020 | |
| tame | 22836 | |
| independientes | 22644 | |
| de | 15005 | 8.0% |
| contados | 13476 | 7.2% |
| creditos | 11753 | 6.3% |
| contado | 11306 | 6.0% |
| arauquita | 8721 | 4.6% |
| indep | 5015 | 2.7% |
| saravena | 4858 | 2.6% |
| Other values (179) | 48272 |
Most occurring characters
| Value | Count | Frequency (%) |
| A | 188987 | |
| E | 178025 | |
| N | 126058 | |
| D | 118287 | |
| O | 114624 | |
| T | 111907 | |
| 96893 | 6.7% | |
| I | 92010 | 6.4% |
| R | 73792 | 5.1% |
| C | 70973 | 4.9% |
| Other values (34) | 268767 |
Most occurring categories
| Value | Count | Frequency (%) |
| Uppercase Letter | 1330412 | |
| Space Separator | 96893 | 6.7% |
| Other Punctuation | 10181 | 0.7% |
| Dash Punctuation | 1022 | 0.1% |
| Open Punctuation | 881 | 0.1% |
| Close Punctuation | 859 | 0.1% |
| Lowercase Letter | 57 | < 0.1% |
| Decimal Number | 18 | < 0.1% |
Most frequent character per category
| Value | Count | Frequency (%) |
| A | 188987 | |
| E | 178025 | |
| N | 126058 | |
| D | 118287 | |
| O | 114624 | |
| T | 111907 | |
| I | 92010 | |
| R | 73792 | 5.5% |
| C | 70973 | 5.3% |
| S | 69158 | 5.2% |
| Other values (18) | 186591 |
| Value | Count | Frequency (%) |
| o | 22 | |
| a | 15 | |
| r | 5 | 8.8% |
| v | 5 | 8.8% |
| e | 5 | 8.8% |
| n | 5 | 8.8% |
| Value | Count | Frequency (%) |
| . | 8285 | |
| , | 1185 | 11.6% |
| " | 702 | 6.9% |
| % | 9 | 0.1% |
| Value | Count | Frequency (%) |
| 6 | 9 | |
| 0 | 9 |
| Value | Count | Frequency (%) |
| 96893 |
| Value | Count | Frequency (%) |
| ( | 881 |
| Value | Count | Frequency (%) |
| ) | 859 |
| Value | Count | Frequency (%) |
| - | 1022 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 1330469 | |
| Common | 109854 | 7.6% |
Most frequent character per script
| Value | Count | Frequency (%) |
| A | 188987 | |
| E | 178025 | |
| N | 126058 | |
| D | 118287 | |
| O | 114624 | |
| T | 111907 | |
| I | 92010 | |
| R | 73792 | 5.5% |
| C | 70973 | 5.3% |
| S | 69158 | 5.2% |
| Other values (24) | 186648 |
| Value | Count | Frequency (%) |
| 96893 | ||
| . | 8285 | 7.5% |
| , | 1185 | 1.1% |
| - | 1022 | 0.9% |
| ( | 881 | 0.8% |
| ) | 859 | 0.8% |
| " | 702 | 0.6% |
| 6 | 9 | < 0.1% |
| 0 | 9 | < 0.1% |
| % | 9 | < 0.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 1440082 | |
| None | 241 | < 0.1% |
Most frequent character per block
| Value | Count | Frequency (%) |
| A | 188987 | |
| E | 178025 | |
| N | 126058 | |
| D | 118287 | |
| O | 114624 | |
| T | 111907 | |
| 96893 | 6.7% | |
| I | 92010 | 6.4% |
| R | 73792 | 5.1% |
| C | 70973 | 4.9% |
| Other values (32) | 268526 |
| Value | Count | Frequency (%) |
| Ñ | 205 | |
| Á | 36 | 14.9% |
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 1 |
| Missing (%) | < 0.1% |
| Memory size | 711.5 KiB |
| PRIVADO | |
|---|---|
| PUBLICO | 6996 |
Length
| Max length | 7 |
|---|---|
| Median length | 7 |
| Mean length | 7 |
| Min length | 7 |
Characters and Unicode
| Total characters | 637350 |
|---|---|
| Distinct characters | 11 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | PUBLICO |
|---|---|
| 2nd row | PUBLICO |
| 3rd row | PUBLICO |
| 4th row | PUBLICO |
| 5th row | PUBLICO |
| Value | Count | Frequency (%) |
| PRIVADO | 84054 | |
| PUBLICO | 6996 | 7.7% |
| (Missing) | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| privado | 84054 | |
| publico | 6996 | 7.7% |
Most occurring characters
| Value | Count | Frequency (%) |
| P | 91050 | |
| I | 91050 | |
| O | 91050 | |
| R | 84054 | |
| V | 84054 | |
| A | 84054 | |
| D | 84054 | |
| U | 6996 | 1.1% |
| B | 6996 | 1.1% |
| L | 6996 | 1.1% |
Most occurring categories
| Value | Count | Frequency (%) |
| Uppercase Letter | 637350 |
Most frequent character per category
| Value | Count | Frequency (%) |
| P | 91050 | |
| I | 91050 | |
| O | 91050 | |
| R | 84054 | |
| V | 84054 | |
| A | 84054 | |
| D | 84054 | |
| U | 6996 | 1.1% |
| B | 6996 | 1.1% |
| L | 6996 | 1.1% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 637350 |
Most frequent character per script
| Value | Count | Frequency (%) |
| P | 91050 | |
| I | 91050 | |
| O | 91050 | |
| R | 84054 | |
| V | 84054 | |
| A | 84054 | |
| D | 84054 | |
| U | 6996 | 1.1% |
| B | 6996 | 1.1% |
| L | 6996 | 1.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 637350 |
Most frequent character per block
| Value | Count | Frequency (%) |
| P | 91050 | |
| I | 91050 | |
| O | 91050 | |
| R | 84054 | |
| V | 84054 | |
| A | 84054 | |
| D | 84054 | |
| U | 6996 | 1.1% |
| B | 6996 | 1.1% |
| L | 6996 | 1.1% |
año_credito
Real number (ℝ≥0)
| Distinct | 26 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2014.573865 |
| Minimum | 1993 |
|---|---|
| Maximum | 2021 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 711.5 KiB |
Quantile statistics
| Minimum | 1993 |
|---|---|
| 5-th percentile | 2004 |
| Q1 | 2012 |
| median | 2016 |
| Q3 | 2019 |
| 95-th percentile | 2020 |
| Maximum | 2021 |
| Range | 28 |
| Interquartile range (IQR) | 7 |
Descriptive statistics
| Standard deviation | 5.234167277 |
|---|---|
| Coefficient of variation (CV) | 0.002598151086 |
| Kurtosis | 0.5839776732 |
| Mean | 2014.573865 |
| Median Absolute Deviation (MAD) | 3 |
| Skewness | -1.068504403 |
| Sum | 183428965 |
| Variance | 27.39650708 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 2020 | 12917 | |
| 2019 | 12395 | |
| 2018 | 7489 | 8.2% |
| 2015 | 7059 | 7.8% |
| 2017 | 6514 | 7.2% |
| 2016 | 5967 | 6.6% |
| 2014 | 5513 | 6.1% |
| 2013 | 4956 | 5.4% |
| 2012 | 4464 | 4.9% |
| 2011 | 3847 | 4.2% |
| Other values (16) | 19930 |
| Value | Count | Frequency (%) |
| 1993 | 1 | < 0.1% |
| 1997 | 206 | 0.2% |
| 1998 | 404 | |
| 1999 | 514 | |
| 2000 | 597 |
| Value | Count | Frequency (%) |
| 2021 | 2020 | 2.2% |
| 2020 | 12917 | |
| 2019 | 12395 | |
| 2018 | 7489 | |
| 2017 | 6514 |
mes_credito
Real number (ℝ≥0)
| Distinct | 12 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 6.831061713 |
| Minimum | 1 |
|---|---|
| Maximum | 12 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 711.5 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 4 |
| median | 7 |
| Q3 | 10 |
| 95-th percentile | 12 |
| Maximum | 12 |
| Range | 11 |
| Interquartile range (IQR) | 6 |
Descriptive statistics
| Standard deviation | 3.481223489 |
|---|---|
| Coefficient of variation (CV) | 0.509616753 |
| Kurtosis | -1.218913564 |
| Mean | 6.831061713 |
| Median Absolute Deviation (MAD) | 3 |
| Skewness | -0.1088082783 |
| Sum | 621975 |
| Variance | 12.11891698 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 12 | 9588 | |
| 10 | 8806 | |
| 11 | 7989 | |
| 9 | 7860 | |
| 7 | 7722 | |
| 6 | 7512 | |
| 5 | 7443 | |
| 8 | 7060 | |
| 3 | 7048 | |
| 2 | 6932 | |
| Other values (2) | 13091 |
| Value | Count | Frequency (%) |
| 1 | 6651 | |
| 2 | 6932 | |
| 3 | 7048 | |
| 4 | 6440 | |
| 5 | 7443 |
| Value | Count | Frequency (%) |
| 12 | 9588 | |
| 11 | 7989 | |
| 10 | 8806 | |
| 9 | 7860 | |
| 8 | 7060 |
| Distinct | 6710 |
|---|---|
| Distinct (%) | 7.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1292388.962 |
| Minimum | 1 |
|---|---|
| Maximum | 299250000 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 711.5 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 60000 |
| Q1 | 350000 |
| median | 882000 |
| Q3 | 1570000 |
| 95-th percentile | 4215500 |
| Maximum | 299250000 |
| Range | 299249999 |
| Interquartile range (IQR) | 1220000 |
Descriptive statistics
| Standard deviation | 1982049.202 |
|---|---|
| Coefficient of variation (CV) | 1.533632103 |
| Kurtosis | 6433.666994 |
| Mean | 1292388.962 |
| Median Absolute Deviation (MAD) | 592000 |
| Skewness | 48.65011979 |
| Sum | 1.176733074 × 1011 |
| Variance | 3.928519038 × 1012 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 100000 | 669 | 0.7% |
| 160000 | 641 | 0.7% |
| 200000 | 633 | 0.7% |
| 1200000 | 628 | 0.7% |
| 180000 | 623 | 0.7% |
| 1000000 | 614 | 0.7% |
| 130000 | 598 | 0.7% |
| 50000 | 595 | 0.7% |
| 400000 | 551 | 0.6% |
| 600000 | 546 | 0.6% |
| Other values (6700) | 84953 |
| Value | Count | Frequency (%) |
| 1 | 1 | < 0.1% |
| 1000 | 6 | |
| 1250 | 1 | < 0.1% |
| 1300 | 1 | < 0.1% |
| 1500 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 299250000 | 1 | |
| 183719000 | 1 | |
| 75160000 | 1 | |
| 41862000 | 1 | |
| 40784000 | 1 |
| Distinct | 8 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 711.5 KiB |
| PAGADO VENCIDO | |
|---|---|
| PAGADO ANTICIPADO | |
| CONTADO | |
| PAGADO A TIEMPO | |
| DESCUENTO EN VENTA | |
| Other values (3) | 1045 |
Length
| Max length | 18 |
|---|---|
| Median length | 14 |
| Mean length | 13.4552833 |
| Min length | 7 |
Characters and Unicode
| Total characters | 1225117 |
|---|---|
| Distinct characters | 17 |
| Distinct categories | 2 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | PAGADO VENCIDO |
|---|---|
| 2nd row | PAGADO VENCIDO |
| 3rd row | PAGADO VENCIDO |
| 4th row | PAGADO VENCIDO |
| 5th row | PAGADO VENCIDO |
| Value | Count | Frequency (%) |
| PAGADO VENCIDO | 38860 | |
| PAGADO ANTICIPADO | 20290 | |
| CONTADO | 19524 | |
| PAGADO A TIEMPO | 5990 | 6.6% |
| DESCUENTO EN VENTA | 5342 | 5.9% |
| DEVOLUCION | 528 | 0.6% |
| CARTERA CASTIGADA | 368 | 0.4% |
| OTROS CIERRES | 149 | 0.2% |
| Value | Count | Frequency (%) |
| pagado | 65140 | |
| vencido | 38860 | |
| anticipado | 20290 | 11.7% |
| contado | 19524 | 11.3% |
| tiempo | 5990 | 3.5% |
| a | 5990 | 3.5% |
| venta | 5342 | 3.1% |
| descuento | 5342 | 3.1% |
| en | 5342 | 3.1% |
| devolucion | 528 | 0.3% |
| Other values (4) | 1034 | 0.6% |
Most occurring characters
| Value | Count | Frequency (%) |
| A | 203556 | |
| O | 176024 | |
| D | 150052 | |
| N | 95228 | |
| P | 91420 | |
| I | 86475 | |
| C | 85429 | |
| 82331 | ||
| E | 67412 | 5.5% |
| G | 65508 | 5.3% |
| Other values (7) | 121682 |
Most occurring categories
| Value | Count | Frequency (%) |
| Uppercase Letter | 1142786 | |
| Space Separator | 82331 | 6.7% |
Most frequent character per category
| Value | Count | Frequency (%) |
| A | 203556 | |
| O | 176024 | |
| D | 150052 | |
| N | 95228 | |
| P | 91420 | |
| I | 86475 | |
| C | 85429 | |
| E | 67412 | 5.9% |
| G | 65508 | 5.7% |
| T | 57373 | 5.0% |
| Other values (6) | 64309 | 5.6% |
| Value | Count | Frequency (%) |
| 82331 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 1142786 | |
| Common | 82331 | 6.7% |
Most frequent character per script
| Value | Count | Frequency (%) |
| A | 203556 | |
| O | 176024 | |
| D | 150052 | |
| N | 95228 | |
| P | 91420 | |
| I | 86475 | |
| C | 85429 | |
| E | 67412 | 5.9% |
| G | 65508 | 5.7% |
| T | 57373 | 5.0% |
| Other values (6) | 64309 | 5.6% |
| Value | Count | Frequency (%) |
| 82331 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 1225117 |
Most frequent character per block
| Value | Count | Frequency (%) |
| A | 203556 | |
| O | 176024 | |
| D | 150052 | |
| N | 95228 | |
| P | 91420 | |
| I | 86475 | |
| C | 85429 | |
| 82331 | ||
| E | 67412 | 5.5% |
| G | 65508 | 5.3% |
| Other values (7) | 121682 |
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 711.5 KiB |
| ELECTRODOMESTICOS | |
|---|---|
| MOTOS | 811 |
Length
| Max length | 17 |
|---|---|
| Median length | 17 |
| Mean length | 16.89311485 |
| Min length | 5 |
Characters and Unicode
| Total characters | 1538135 |
|---|---|
| Distinct characters | 10 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | ELECTRODOMESTICOS |
|---|---|
| 2nd row | ELECTRODOMESTICOS |
| 3rd row | ELECTRODOMESTICOS |
| 4th row | ELECTRODOMESTICOS |
| 5th row | ELECTRODOMESTICOS |
| Value | Count | Frequency (%) |
| ELECTRODOMESTICOS | 90240 | |
| MOTOS | 811 | 0.9% |
| Value | Count | Frequency (%) |
| electrodomesticos | 90240 | |
| motos | 811 | 0.9% |
Most occurring characters
| Value | Count | Frequency (%) |
| O | 272342 | |
| E | 270720 | |
| T | 181291 | |
| S | 181291 | |
| C | 180480 | |
| M | 91051 | 5.9% |
| L | 90240 | 5.9% |
| R | 90240 | 5.9% |
| D | 90240 | 5.9% |
| I | 90240 | 5.9% |
Most occurring categories
| Value | Count | Frequency (%) |
| Uppercase Letter | 1538135 |
Most frequent character per category
| Value | Count | Frequency (%) |
| O | 272342 | |
| E | 270720 | |
| T | 181291 | |
| S | 181291 | |
| C | 180480 | |
| M | 91051 | 5.9% |
| L | 90240 | 5.9% |
| R | 90240 | 5.9% |
| D | 90240 | 5.9% |
| I | 90240 | 5.9% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 1538135 |
Most frequent character per script
| Value | Count | Frequency (%) |
| O | 272342 | |
| E | 270720 | |
| T | 181291 | |
| S | 181291 | |
| C | 180480 | |
| M | 91051 | 5.9% |
| L | 90240 | 5.9% |
| R | 90240 | 5.9% |
| D | 90240 | 5.9% |
| I | 90240 | 5.9% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 1538135 |
Most frequent character per block
| Value | Count | Frequency (%) |
| O | 272342 | |
| E | 270720 | |
| T | 181291 | |
| S | 181291 | |
| C | 180480 | |
| M | 91051 | 5.9% |
| L | 90240 | 5.9% |
| R | 90240 | 5.9% |
| D | 90240 | 5.9% |
| I | 90240 | 5.9% |
| Distinct | 4 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 711.5 KiB |
| MENSUAL(ES) | |
|---|---|
| DIARIA(S) | |
| SEMANAL(ES) | 775 |
| QUINCENAL(ES) | 252 |
Length
| Max length | 13 |
|---|---|
| Median length | 11 |
| Mean length | 10.64013575 |
| Min length | 9 |
Characters and Unicode
| Total characters | 968795 |
|---|---|
| Distinct characters | 14 |
| Distinct categories | 3 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | MENSUAL(ES) |
|---|---|
| 2nd row | MENSUAL(ES) |
| 3rd row | MENSUAL(ES) |
| 4th row | MENSUAL(ES) |
| 5th row | MENSUAL(ES) |
| Value | Count | Frequency (%) |
| MENSUAL(ES) | 73389 | |
| DIARIA(S) | 16635 | 18.3% |
| SEMANAL(ES) | 775 | 0.9% |
| QUINCENAL(ES) | 252 | 0.3% |
| Value | Count | Frequency (%) |
| mensual(es | 73389 | |
| diaria(s | 16635 | 18.3% |
| semanal(es | 775 | 0.9% |
| quincenal(es | 252 | 0.3% |
Most occurring characters
| Value | Count | Frequency (%) |
| S | 165215 | |
| E | 148832 | |
| A | 108461 | |
| ( | 91051 | |
| ) | 91051 | |
| N | 74668 | |
| L | 74416 | |
| M | 74164 | |
| U | 73641 | |
| I | 33522 | 3.5% |
| Other values (4) | 33774 | 3.5% |
Most occurring categories
| Value | Count | Frequency (%) |
| Uppercase Letter | 786693 | |
| Open Punctuation | 91051 | 9.4% |
| Close Punctuation | 91051 | 9.4% |
Most frequent character per category
| Value | Count | Frequency (%) |
| S | 165215 | |
| E | 148832 | |
| A | 108461 | |
| N | 74668 | |
| L | 74416 | |
| M | 74164 | |
| U | 73641 | |
| I | 33522 | 4.3% |
| D | 16635 | 2.1% |
| R | 16635 | 2.1% |
| Other values (2) | 504 | 0.1% |
| Value | Count | Frequency (%) |
| ( | 91051 |
| Value | Count | Frequency (%) |
| ) | 91051 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 786693 | |
| Common | 182102 | 18.8% |
Most frequent character per script
| Value | Count | Frequency (%) |
| S | 165215 | |
| E | 148832 | |
| A | 108461 | |
| N | 74668 | |
| L | 74416 | |
| M | 74164 | |
| U | 73641 | |
| I | 33522 | 4.3% |
| D | 16635 | 2.1% |
| R | 16635 | 2.1% |
| Other values (2) | 504 | 0.1% |
| Value | Count | Frequency (%) |
| ( | 91051 | |
| ) | 91051 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 968795 |
Most frequent character per block
| Value | Count | Frequency (%) |
| S | 165215 | |
| E | 148832 | |
| A | 108461 | |
| ( | 91051 | |
| ) | 91051 | |
| N | 74668 | |
| L | 74416 | |
| M | 74164 | |
| U | 73641 | |
| I | 33522 | 3.5% |
| Other values (4) | 33774 | 3.5% |
cuotas
Real number (ℝ≥0)
| Distinct | 320 |
|---|---|
| Distinct (%) | 0.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 7.93415778 |
| Minimum | 0 |
|---|---|
| Maximum | 959 |
| Zeros | 1 |
| Zeros (%) | < 0.1% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 711.5 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 1 |
| median | 3 |
| Q3 | 9 |
| 95-th percentile | 15 |
| Maximum | 959 |
| Range | 959 |
| Interquartile range (IQR) | 8 |
Descriptive statistics
| Standard deviation | 23.3819336 |
|---|---|
| Coefficient of variation (CV) | 2.946996298 |
| Kurtosis | 212.8928241 |
| Mean | 7.93415778 |
| Median Absolute Deviation (MAD) | 2 |
| Skewness | 11.09347136 |
| Sum | 722413 |
| Variance | 546.7148191 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 1 | 40621 | |
| 10 | 8973 | 9.9% |
| 5 | 8546 | 9.4% |
| 3 | 4197 | 4.6% |
| 2 | 4157 | 4.6% |
| 12 | 3881 | 4.3% |
| 6 | 3654 | 4.0% |
| 4 | 2897 | 3.2% |
| 14 | 2400 | 2.6% |
| 9 | 2365 | 2.6% |
| Other values (310) | 9360 | 10.3% |
| Value | Count | Frequency (%) |
| 0 | 1 | < 0.1% |
| 1 | 40621 | |
| 2 | 4157 | 4.6% |
| 3 | 4197 | 4.6% |
| 4 | 2897 | 3.2% |
| Value | Count | Frequency (%) |
| 959 | 1 | |
| 920 | 2 | |
| 909 | 1 | |
| 801 | 1 | |
| 546 | 1 |
| Distinct | 3 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 711.5 KiB |
| CRÉDITO | |
|---|---|
| CONTADO | |
| LIBRANZA | 2464 |
Length
| Max length | 8 |
|---|---|
| Median length | 7 |
| Mean length | 7.027061757 |
| Min length | 7 |
Characters and Unicode
| Total characters | 639821 |
|---|---|
| Distinct characters | 12 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 2 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | LIBRANZA |
|---|---|
| 2nd row | LIBRANZA |
| 3rd row | LIBRANZA |
| 4th row | CRÉDITO |
| 5th row | CRÉDITO |
| Value | Count | Frequency (%) |
| CRÉDITO | 69063 | |
| CONTADO | 19524 | 21.4% |
| LIBRANZA | 2464 | 2.7% |
| Value | Count | Frequency (%) |
| crédito | 69063 | |
| contado | 19524 | 21.4% |
| libranza | 2464 | 2.7% |
Most occurring characters
| Value | Count | Frequency (%) |
| O | 108111 | |
| C | 88587 | |
| D | 88587 | |
| T | 88587 | |
| I | 71527 | |
| R | 71527 | |
| É | 69063 | |
| A | 24452 | 3.8% |
| N | 21988 | 3.4% |
| L | 2464 | 0.4% |
| Other values (2) | 4928 | 0.8% |
Most occurring categories
| Value | Count | Frequency (%) |
| Uppercase Letter | 639821 |
Most frequent character per category
| Value | Count | Frequency (%) |
| O | 108111 | |
| C | 88587 | |
| D | 88587 | |
| T | 88587 | |
| I | 71527 | |
| R | 71527 | |
| É | 69063 | |
| A | 24452 | 3.8% |
| N | 21988 | 3.4% |
| L | 2464 | 0.4% |
| Other values (2) | 4928 | 0.8% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 639821 |
Most frequent character per script
| Value | Count | Frequency (%) |
| O | 108111 | |
| C | 88587 | |
| D | 88587 | |
| T | 88587 | |
| I | 71527 | |
| R | 71527 | |
| É | 69063 | |
| A | 24452 | 3.8% |
| N | 21988 | 3.4% |
| L | 2464 | 0.4% |
| Other values (2) | 4928 | 0.8% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 570758 | |
| None | 69063 | 10.8% |
Most frequent character per block
| Value | Count | Frequency (%) |
| O | 108111 | |
| C | 88587 | |
| D | 88587 | |
| T | 88587 | |
| I | 71527 | |
| R | 71527 | |
| A | 24452 | 4.3% |
| N | 21988 | 3.9% |
| L | 2464 | 0.4% |
| B | 2464 | 0.4% |
| Value | Count | Frequency (%) |
| É | 69063 |
Pearson's r
The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.
Spearman's ρ
The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.
Kendall's τ
Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.
Phik (φk)
Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.Cramér's V (φc)
Cramér's V is an association measure for nominal random variables. The coefficient ranges from 0 to 1, with 0 indicating independence and 1 indicating perfect association. The empirical estimators used for Cramér's V have been proved to be biased, even for large samples. We use a bias-corrected measure that has been proposed by Bergsma in 2013 that can be found here.First rows
| Row | tipo_identificacion | genero | estado_civil | edad | municipio_residencia | tipo_persona | empresa | municipio_nacimiento | municipio_expedicion | tiene_casa_propia | cargo | sueldo | tiempo_servicio | otros_ingresos_mensual | otros_ingresos_concepto | municipio_credito | codeudor | entidad | sector | año_credito | mes_credito | valor_credito | estado_final | tipo_venta | periodo_credito | cuotas | forma_pago | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 1 | Cedula de Ciudadania | Femenino | Soltero | 47 | ARAUCA | Natural | ALCALDIA DE ARAUCA | ARAUCA | ARAUCA | Si | PROFESIONAL DE APOYO | 908526 | 21 AÑOS | NaN | NaN | ARAUCA | SIN CODEUDOR | ALCALDIA DE ARAUCA | PUBLICO | 2008 | 12 | 205000 | PAGADO VENCIDO | ELECTRODOMESTICOS | MENSUAL(ES) | 1 | LIBRANZA |
| 1 | 2 | Cedula de Ciudadania | Femenino | Union Libre | 66 | ARAUCA | Natural | ALCALDIA DE ARAUCA | ARAUCA | ARAUCA | No | INSPECTORA DE POLICIA | 5500000 | 25 AÑOS | NaN | NaN | ARAUCA | SIN CODEUDOR | ALCALDIA DE ARAUCA | PUBLICO | 2009 | 2 | 143000 | PAGADO VENCIDO | ELECTRODOMESTICOS | MENSUAL(ES) | 1 | LIBRANZA |
| 2 | 3 | Cedula de Ciudadania | Femenino | Union Libre | 66 | ARAUCA | Natural | ALCALDIA DE ARAUCA | ARAUCA | ARAUCA | No | INSPECTORA DE POLICIA | 5500000 | 25 AÑOS | NaN | NaN | ARAUCA | SIN CODEUDOR | ALCALDIA DE ARAUCA | PUBLICO | 2009 | 6 | 680000 | PAGADO VENCIDO | ELECTRODOMESTICOS | MENSUAL(ES) | 7 | LIBRANZA |
| 3 | 4 | Cedula de Ciudadania | Femenino | Casado | 49 | ARAUCA | Natural | ALCALDIA DE ARAUCA | ARAUCA | ARAUCA | Si | PROFESIONAL UNIVERSITARIA | 4875000 | 23 AÑOS | 4200000.0 | GANADERIA | ARAUCA | SIN CODEUDOR | ALCALDIA DE ARAUCA | PUBLICO | 2009 | 9 | 611000 | PAGADO VENCIDO | ELECTRODOMESTICOS | MENSUAL(ES) | 4 | CRÉDITO |
| 4 | 5 | Cedula de Ciudadania | Femenino | Soltero | 47 | ARAUCA | Natural | ALCALDIA DE ARAUCA | ARAUCA | ARAUCA | Si | PROFESIONAL DE APOYO | 908526 | 21 AÑOS | NaN | NaN | ARAUCA | SIN CODEUDOR | ALCALDIA DE ARAUCA | PUBLICO | 2009 | 10 | 1755000 | PAGADO VENCIDO | ELECTRODOMESTICOS | MENSUAL(ES) | 12 | CRÉDITO |
| 5 | 6 | Cedula de Ciudadania | Femenino | Union Libre | 66 | ARAUCA | Natural | ALCALDIA DE ARAUCA | ARAUCA | ARAUCA | No | INSPECTORA DE POLICIA | 5500000 | 25 AÑOS | NaN | NaN | ARAUCA | SIN CODEUDOR | ALCALDIA DE ARAUCA | PUBLICO | 2009 | 11 | 2250000 | PAGADO VENCIDO | ELECTRODOMESTICOS | MENSUAL(ES) | 14 | CRÉDITO |
| 6 | 7 | Cedula de Ciudadania | Femenino | Casado | 49 | ARAUCA | Natural | ALCALDIA DE ARAUCA | ARAUCA | ARAUCA | Si | ALMACENISTA | 3200000 | 31 AÑOS | 0.0 | NaN | ARAUCA | SIN CODEUDOR | ALCALDIA DE ARAUCA | PUBLICO | 2009 | 11 | 2760000 | PAGADO VENCIDO | ELECTRODOMESTICOS | MENSUAL(ES) | 9 | CRÉDITO |
| 7 | 8 | Cedula de Ciudadania | Femenino | Soltero | 49 | ARAUCA | Natural | ALCALDIA DE ARAUCA | ARAUCA | ARAUCA | Si | PROFESIONAL UNIVERSITARIO | 4200000 | 20 AÑOS | 0.0 | NaN | ARAUCA | SIN CODEUDOR | ALCALDIA DE ARAUCA | PUBLICO | 2009 | 11 | 2955000 | PAGADO VENCIDO | ELECTRODOMESTICOS | MENSUAL(ES) | 14 | CRÉDITO |
| 8 | 9 | Cedula de Ciudadania | Femenino | Soltero | 59 | ARAUCA | Natural | ALCALDIA DE ARAUCA | ARAUCA | ARAUCA | No | OFICINA INCLUSION SOCIAL | 2000000 | 30 AÑOS | NaN | NaN | ARAUCA | SIN CODEUDOR | ALCALDIA DE ARAUCA | PUBLICO | 2009 | 11 | 1932000 | DESCUENTO EN VENTA | ELECTRODOMESTICOS | MENSUAL(ES) | 11 | CRÉDITO |
| 9 | 10 | Cedula de Ciudadania | Femenino | Union Libre | 48 | ARAUCA | Natural | ALCALDIA DE ARAUCA | ARAUCA | ARAUCA | No | SECRETARIA | 2500000 | 10 AÑOS | 0.0 | NaN | ARAUCA | SIN CODEUDOR | ALCALDIA DE ARAUCA | PUBLICO | 2008 | 2 | 260000 | PAGADO ANTICIPADO | ELECTRODOMESTICOS | MENSUAL(ES) | 4 | LIBRANZA |
Last rows
| Row | tipo_identificacion | genero | estado_civil | edad | municipio_residencia | tipo_persona | empresa | municipio_nacimiento | municipio_expedicion | tiene_casa_propia | cargo | sueldo | tiempo_servicio | otros_ingresos_mensual | otros_ingresos_concepto | municipio_credito | codeudor | entidad | sector | año_credito | mes_credito | valor_credito | estado_final | tipo_venta | periodo_credito | cuotas | forma_pago | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 91041 | 91042 | Cedula de Ciudadania | Masculino | Casado | 37 | ARAUQUITA | Natural | AUTOSERVICIO BLESSED | ARAUQUITA | ARAUQUITA | Si | PROPIETARIO | 5000000 | 3 AÑOS | NaN | NaN | ARAUQUITA | SIN CODEUDOR | INDEP. ARAUQUITA | PRIVADO | 2015 | 9 | 1740000 | PAGADO ANTICIPADO | ELECTRODOMESTICOS | MENSUAL(ES) | 3 | CRÉDITO |
| 91042 | 91043 | Cedula de Ciudadania | Masculino | Union Libre | 54 | ARAUQUITA | Natural | SEAD ARAUCA | ARAUQUITA | ARAUQUITA | Si | RECTOR | 4000000 | NaN | NaN | NaN | ARAUQUITA | SIN CODEUDOR | INDEP. ARAUQUITA | PRIVADO | 2015 | 9 | 430000 | PAGADO ANTICIPADO | ELECTRODOMESTICOS | MENSUAL(ES) | 3 | CRÉDITO |
| 91043 | 91044 | Cedula de Ciudadania | Masculino | Union Libre | 34 | ARAUQUITA | Natural | INDEPENDIENTE | ARAUQUITA | ARAUQUITA | Si | PROPIETARIO | 1000000 | 8 AÑOS | NaN | NaN | ARAUQUITA | SIN CODEUDOR | INDEP. ARAUQUITA | PRIVADO | 2015 | 9 | 1600000 | PAGADO ANTICIPADO | ELECTRODOMESTICOS | MENSUAL(ES) | 10 | CRÉDITO |
| 91044 | 91045 | Cedula de Ciudadania | Masculino | Union Libre | 32 | ARAUQUITA | Natural | INDEPENDIENTE | ARAUQUITA | ARAUQUITA | Si | MOTOTAXISTA | 1500000 | 2 AÑOS | 0.0 | 0 | ARAUQUITA | SIN CODEUDOR | INDEP. ARAUQUITA | PRIVADO | 2015 | 9 | 125000 | PAGADO ANTICIPADO | ELECTRODOMESTICOS | MENSUAL(ES) | 1 | CRÉDITO |
| 91045 | 91046 | Cedula de Ciudadania | Masculino | Soltero | 44 | ARAUQUITA | Natural | HOSPITAL | ARAUQUITA | ARAUQUITA | Si | ASISTENCIA ADMINISTRATIVO | 1300000 | 9 AÑOS | NaN | NaN | ARAUQUITA | CON CODEUDOR | INDEP. ARAUQUITA | PRIVADO | 2015 | 9 | 800000 | PAGADO VENCIDO | ELECTRODOMESTICOS | MENSUAL(ES) | 8 | CRÉDITO |
| 91046 | 91047 | Cedula de Ciudadania | Masculino | Union Libre | 59 | ARAUQUITA | Natural | ALCALDIA DE ARAUQUITA | ARAUQUITA | ARAUQUITA | Si | CONDUCTOR SERVICIOS PUBLICOS | 2200000 | 28 AÑOS | NaN | NaN | ARAUQUITA | SIN CODEUDOR | INDEP. ARAUQUITA | PRIVADO | 2015 | 9 | 868000 | PAGADO ANTICIPADO | ELECTRODOMESTICOS | MENSUAL(ES) | 3 | CRÉDITO |
| 91047 | 91048 | Cedula de Ciudadania | Masculino | Casado | 47 | ARAUQUITA | Natural | INDEPENDIENTE | ARAUQUITA | ARAUQUITA | Si | ADMINISTRADOR FINCA | 800000 | 7 AÑOS | NaN | NaN | ARAUQUITA | SIN CODEUDOR | INDEP. ARAUQUITA | PRIVADO | 2015 | 8 | 1350000 | PAGADO ANTICIPADO | ELECTRODOMESTICOS | MENSUAL(ES) | 10 | CRÉDITO |
| 91048 | 91049 | Cedula de Ciudadania | Masculino | Casado | 37 | ARAUQUITA | Natural | INDEPENDIENTE | ARAUQUITA | ARAUQUITA | Si | COMERCIANTE | 1000000 | 20 AÑOS | NaN | NaN | ARAUQUITA | SIN CODEUDOR | INDEP. ARAUQUITA | PRIVADO | 2015 | 9 | 980000 | PAGADO VENCIDO | ELECTRODOMESTICOS | MENSUAL(ES) | 6 | CRÉDITO |
| 91049 | 91050 | Cedula de Ciudadania | Masculino | Union Libre | 34 | ARAUQUITA | Natural | INDEPENDIENTE | ARAUQUITA | ARAUQUITA | Si | COMERCIANTE | 1000000 | 2 AÑOS | NaN | NaN | ARAUQUITA | SIN CODEUDOR | INDEP. ARAUQUITA | PRIVADO | 2015 | 9 | 1050000 | PAGADO ANTICIPADO | ELECTRODOMESTICOS | MENSUAL(ES) | 2 | CRÉDITO |
| 91050 | 91051 | Cedula de Ciudadania | Masculino | Union Libre | 31 | ARAUQUITA | Natural | RYR SOLUCIONES | ARAUQUITA | ARAUQUITA | Si | TECNICO ELECTRICISTA | 1500000 | 3 AÑOS | NaN | NaN | ARAUQUITA | SIN CODEUDOR | INDEP. ARAUQUITA | PRIVADO | 2015 | 9 | 838000 | PAGADO ANTICIPADO | ELECTRODOMESTICOS | MENSUAL(ES) | 3 | CRÉDITO |